object DSServerBroker: TDSServerBroker
  OldCreateOrder = False
  Height = 437
  Width = 760
  object WAR_APP: TSQLConnection
    ConnectionName = 'WAR_APP'
    DriverName = 'ORACLE'
    GetDriverFunc = 'getSQLDriverORACLE'
    LibraryName = 'dbxora.dll'
    LoginPrompt = False
    Params.Strings = (
      'DriverUnit=Data.DBXOracle'
      
        'DriverPackageLoader=TDBXDynalinkDriverLoader,DBXCommonDriver160.' +
        'bpl'
      
        'DriverAssemblyLoader=Borland.Data.TDBXDynalinkDriverLoader,Borla' +
        'nd.Data.DbxCommonDriver,Version=16.0.0.0,Culture=neutral,PublicK' +
        'eyToken=91d62ebb5b0d1b1b'
      
        'MetaDataPackageLoader=TDBXOracleMetaDataCommandFactory,DbxOracle' +
        'Driver160.bpl'
      
        'MetaDataAssemblyLoader=Borland.Data.TDBXOracleMetaDataCommandFac' +
        'tory,Borland.Data.DbxOracleDriver,Version=16.0.0.0,Culture=neutr' +
        'al,PublicKeyToken=91d62ebb5b0d1b1b'
      'GetDriverFunc=getSQLDriverORACLE'
      'LibraryName=dbxora.dll'
      'VendorLib=oci.dll'
      'MaxBlobSize=-1'
      'OSAuthentication=False'
      'MultipleTransactions=False'
      'TrimChar=False'
      'ErrorResourceFile='
      'drivername=ORACLE'
      'librarynameosx=libsqlora.dylib'
      'vendorlibwin64=oci.dll'
      'vendorlibosx=libociei.dylib'
      'database=XE'
      'User_Name=WAR_APP'
      'Password=WAR_APP'
      'blobsize=-1'
      'localecode=0000'
      'isolationlevel=ReadCommitted'
      'rowsetsize=20'
      'os authentication=False'
      'multiple transaction=False'
      'trim char=False'
      'decimal separator=.'
      'UseUnicode=True'
      'DelegateConnection=DBXTrace'
      
        'DBXTrace.TraceFlags=PARAMETER;ERROR;EXECUTE;COMMAND;CONNECT;TRAN' +
        'SACT;BLOB;MISC;VENDOR;READER;DRIVER_LOAD;METADATA'
      'DBXTrace.DriverUnit=Data.DBXTrace'
      'DBXTrace.DelegateDriver=True'
      'DBXTrace.TraceFile=WAR_APP_Trace.log'
      'DBXTrace.TraceDriver=False'
      'DBXTrace.DriverName=DBXTrace')
    VendorLib = 'oci.dll'
    AfterConnect = WAR_APPAfterConnect
    Connected = True
    Left = 170
    Top = 10
  end
  object WAR_APP_URLQUEUE: TSQLDataSet
    SchemaName = 'WAR_APP'
    CommandText = 'WAR_APP_URLQUEUE'
    CommandType = ctTable
    DbxCommandType = 'Dbx.Table'
    MaxBlobSize = -1
    Params = <>
    SQLConnection = WAR_APP
    Left = 45
    Top = 77
  end
  object dspURLQueue: TDataSetProvider
    DataSet = WAR_APP_URLQUEUE
    Left = 48
    Top = 128
  end
  object QRY_URLQUEUE_PENDING: TSQLDataSet
    SchemaName = 'WAR_APP'
    CommandText = 
      'SELECT "NAME","REALM","LASTMODIFIED","URLVALUE","PRIORITY","STAT' +
      'US","REQUESTERID","REQUESTTIME","REQUESTTRY", "REQUESTRESULT", "' +
      'REQUESTHTTPCODE", "TYPE" from WAR_APP_URLQUEUE where status = 0 ' +
      'AND REQUESTERID = '#39'NONE'#39' and rownum = 1 order by priority desc'
    DbxCommandType = 'Dbx.SQL'
    MaxBlobSize = -1
    Params = <>
    SQLConnection = WAR_APP
    Left = 171
    Top = 75
  end
  object dspURLQueuePending: TDataSetProvider
    DataSet = QRY_URLQUEUE_PENDING
    Options = [poAllowCommandText, poUseQuoteChar]
    UpdateMode = upWhereKeyOnly
    OnUpdateError = dspURLQueuePendingUpdateError
    Left = 168
    Top = 128
  end
  object requesterDataset: TSQLDataSet
    SchemaName = 'WAR_APP'
    CommandText = 
      'select *  from WAR_APP_URLQUEUE where STATUS < 2 and REQUESTERID' +
      ' = :RequesterId'
    DbxCommandType = 'Dbx.SQL'
    MaxBlobSize = -1
    Params = <
      item
        DataType = ftUnknown
        Name = 'RequesterId'
        ParamType = ptInput
      end>
    SQLConnection = WAR_APP
    Left = 288
    Top = 72
  end
  object dspRequesterData: TDataSetProvider
    DataSet = requesterDataset
    Options = [poAllowCommandText, poUseQuoteChar]
    UpdateMode = upWhereKeyOnly
    Left = 288
    Top = 128
  end
  object mySqlMonitor: TSQLMonitor
    Active = True
    AutoSave = True
    FileName = 
      'C:\Users\jp\Documents\RAD Studio\Projets\WAR\Broker_tracessql.lo' +
      'g'
    OnLogTrace = mySqlMonitorLogTrace
    SQLConnection = WAR_APP
    Left = 624
    Top = 40
  end
  object WAR_DAT: TSQLConnection
    ConnectionName = 'WAR_DAT'
    DriverName = 'ORACLE'
    GetDriverFunc = 'getSQLDriverORACLE'
    LibraryName = 'dbxora.dll'
    LoginPrompt = False
    Params.Strings = (
      'drivername=ORACLE'
      'librarynameosx=libsqlora.dylib'
      'vendorlibwin64=oci.dll'
      'vendorlibosx=libociei.dylib'
      'Database=XE'
      'User_Name=WAR_DAT'
      'Password=WAR_DAT'
      'blobsize=-1'
      'localecode=0000'
      'isolationlevel=ReadCommitted'
      'rowsetsize=20'
      'os authentication=False'
      'multiple transaction=False'
      'trim char=False'
      'decimal separator=.')
    VendorLib = 'oci.dll'
    AfterConnect = WAR_DATAfterConnect
    Connected = True
    Left = 394
    Top = 10
  end
  object RealmsDataset: TSQLDataSet
    SchemaName = 'WAR_DAT'
    CommandText = 'select * from WAR_DAT_REALMS'
    DbxCommandType = 'Dbx.SQL'
    MaxBlobSize = -1
    Params = <>
    SQLConnection = WAR_DAT
    Left = 389
    Top = 69
  end
  object dspRealms: TDataSetProvider
    DataSet = RealmsDataset
    Options = [poAllowCommandText, poUseQuoteChar]
    UpdateMode = upWhereKeyOnly
    Left = 392
    Top = 128
  end
end
